EMT Practice Test

1. Question Content...

---

Question1: Execute the Alpha_NACustomer_Job in debug mode with a subset of records. In the workspace for the Alpha_NACustomer_Job , add a filter between the source and the Query transform to filter the records, so that only customers from the USA are included in the debug session?

Question2: Contains repository names associated with the Job Server on which you run_______?

Question3: Contains repository names that are associated with the Job Server on which you run your jobs. Which is the actual option to see jobs status?

Question4: You are working as an ETL developer using SAP Data Services Designer. To whom You will create Datastores?

Question5: Which syntax rules must you follow in the SAP
Data Services scripting language?

Question6: Where does An administrator sets user permissions?

Question7: How to Use a WHERE clause to select only customers in North America
(North American countries are United States, Canada, and Mexico which have COUNTRYID values of 1, 2,and 11)?

Question8: The Marketing department would like to send special offers to customers who have placed a specified number of orders. This can be done by creating a custom function that must be called when a customer order is placed.
You want to create a custom function to accept the input parameters of the Customer ID, and the number of orders required to receive a special order, check the Orders table, and then create an initial list of eligible customers.

Question9: You must calculate the total value of all orders, including their discounts, for reporting purposes.
Currently these details are found in different tables.
Use the sum function to calculate the total value of orders in the Order_Details table.
How to Execute the Alpha_Order_Sum_Job with the default execution properties after saving all of the objects that you have created.

Question10: During development of a SAP Data Services dataflow, you find that the source system contains data inconsistencies.
What transform allows you to define rules and monitor the conformance of the data for every load?

Question11: To ensure that your job is processing the data correctly, you wan to run the job in debug mode. To minimize the data you have to review in the interactive debugger, you set the debug option process to show only records from an individual CountryID field value.
In the Cloud/WTS environment, the Designer will not allow multiple users to share the interactive debugger port. Change the interactive debugger port in Designer options.

Question12: Where is an SAP Data Services job executed?

Question13: You must calculate the total value of all orders, including their discounts, for reporting purposes. Currently these details are found in different tables.
Use the sum function to calculate the total value of orders in the Order_Details table.
How to in the Query transform, create a new output column
TOTAL_VALUE , which will hold the new calculation.

Question14: The Marketing department would like to send special offers to customers who have placed a specified number of orders. This can be done by creating a custom function that must be called when a customer order is placed.
You want to create a custom function to accept the input parameters of the Customer ID, and the number of orders required to receive a special order, check the Orders table, and then create an initial list of eligible customers.
How to In the Local Object Library, create a new customer function called CF_MarketingOffer.

Question15: You must ensure that all records from the Customer table in the Alpha database are being moved to the Delta staging database using the audit logs.
In the Local Object Library, replicate the Alpha_NACustomer_DF data flow. Name the replicated data flow Alpha_AuditCustomer_DF . Add the replicated data flow to a new job, Alpha_AuditCustomer_Job . Set up auditing on the data flow Alpha_AuditCustomer_DF by adding an audit rule to compare the total number of records in the source and target tables.
How to Add the Alpha_AuditCustomer_DF to the Alpha_AuditCustomer_Job .

Question16: _________through which SAP Data Services connects to this
SAP application server. Use the same user name used to create the SAP BW Source datastore.

Question17: You must calculate the total value of all orders, including their discounts, for reporting purposes. Currently these details are found in different tables.
Use the sum function to calculate the total value of orders in the Order_Details table.
How to create a new batch job called Alpha_Order_Sum_Job with a data flow Alpha_Order_Sum_DF .

Question18: In which parameter the number of minutes a profiling task can be inactive before the Data Profiler cancels it?

Question19: When you log in to the Management Console, Where you must log in as a user defined?